package com.dorado.example.model;

import com.dorado.kernel.base.model.BaseExample;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class CompanyExample extends BaseExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CompanyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andPidIsNull() {
            addCriterion("pid is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("pid is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(Integer value) {
            addCriterion("pid =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(Integer value) {
            addCriterion("pid <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(Integer value) {
            addCriterion("pid >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(Integer value) {
            addCriterion("pid >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(Integer value) {
            addCriterion("pid <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(Integer value) {
            addCriterion("pid <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<Integer> values) {
            addCriterion("pid in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<Integer> values) {
            addCriterion("pid not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(Integer value1, Integer value2) {
            addCriterion("pid between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(Integer value1, Integer value2) {
            addCriterion("pid not between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andMktimeIsNull() {
            addCriterion("mktime is null");
            return (Criteria) this;
        }

        public Criteria andMktimeIsNotNull() {
            addCriterion("mktime is not null");
            return (Criteria) this;
        }

        public Criteria andMktimeEqualTo(Date value) {
            addCriterion("mktime =", value, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeNotEqualTo(Date value) {
            addCriterion("mktime <>", value, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeGreaterThan(Date value) {
            addCriterion("mktime >", value, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeGreaterThanOrEqualTo(Date value) {
            addCriterion("mktime >=", value, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeLessThan(Date value) {
            addCriterion("mktime <", value, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeLessThanOrEqualTo(Date value) {
            addCriterion("mktime <=", value, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeIn(List<Date> values) {
            addCriterion("mktime in", values, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeNotIn(List<Date> values) {
            addCriterion("mktime not in", values, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeBetween(Date value1, Date value2) {
            addCriterion("mktime between", value1, value2, "mktime");
            return (Criteria) this;
        }

        public Criteria andMktimeNotBetween(Date value1, Date value2) {
            addCriterion("mktime not between", value1, value2, "mktime");
            return (Criteria) this;
        }

        public Criteria andUpdatedIsNull() {
            addCriterion("updated is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedIsNotNull() {
            addCriterion("updated is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedEqualTo(Date value) {
            addCriterion("updated =", value, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedNotEqualTo(Date value) {
            addCriterion("updated <>", value, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedGreaterThan(Date value) {
            addCriterion("updated >", value, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedGreaterThanOrEqualTo(Date value) {
            addCriterion("updated >=", value, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedLessThan(Date value) {
            addCriterion("updated <", value, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedLessThanOrEqualTo(Date value) {
            addCriterion("updated <=", value, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedIn(List<Date> values) {
            addCriterion("updated in", values, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedNotIn(List<Date> values) {
            addCriterion("updated not in", values, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedBetween(Date value1, Date value2) {
            addCriterion("updated between", value1, value2, "updated");
            return (Criteria) this;
        }

        public Criteria andUpdatedNotBetween(Date value1, Date value2) {
            addCriterion("updated not between", value1, value2, "updated");
            return (Criteria) this;
        }

        public Criteria andUidIsNull() {
            addCriterion("uid is null");
            return (Criteria) this;
        }

        public Criteria andUidIsNotNull() {
            addCriterion("uid is not null");
            return (Criteria) this;
        }

        public Criteria andUidEqualTo(Integer value) {
            addCriterion("uid =", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotEqualTo(Integer value) {
            addCriterion("uid <>", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThan(Integer value) {
            addCriterion("uid >", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThanOrEqualTo(Integer value) {
            addCriterion("uid >=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThan(Integer value) {
            addCriterion("uid <", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThanOrEqualTo(Integer value) {
            addCriterion("uid <=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidIn(List<Integer> values) {
            addCriterion("uid in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotIn(List<Integer> values) {
            addCriterion("uid not in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidBetween(Integer value1, Integer value2) {
            addCriterion("uid between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotBetween(Integer value1, Integer value2) {
            addCriterion("uid not between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Byte value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Byte value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Byte value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Byte value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Byte value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Byte value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Byte> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Byte> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Byte value1, Byte value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Byte value1, Byte value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andLawRealnameIsNull() {
            addCriterion("law_realname is null");
            return (Criteria) this;
        }

        public Criteria andLawRealnameIsNotNull() {
            addCriterion("law_realname is not null");
            return (Criteria) this;
        }

        public Criteria andLawRealnameEqualTo(String value) {
            addCriterion("law_realname =", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameNotEqualTo(String value) {
            addCriterion("law_realname <>", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameGreaterThan(String value) {
            addCriterion("law_realname >", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameGreaterThanOrEqualTo(String value) {
            addCriterion("law_realname >=", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameLessThan(String value) {
            addCriterion("law_realname <", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameLessThanOrEqualTo(String value) {
            addCriterion("law_realname <=", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameLike(String value) {
            addCriterion("law_realname like", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameNotLike(String value) {
            addCriterion("law_realname not like", value, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameIn(List<String> values) {
            addCriterion("law_realname in", values, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameNotIn(List<String> values) {
            addCriterion("law_realname not in", values, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameBetween(String value1, String value2) {
            addCriterion("law_realname between", value1, value2, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawRealnameNotBetween(String value1, String value2) {
            addCriterion("law_realname not between", value1, value2, "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeIsNull() {
            addCriterion("law_id_code is null");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeIsNotNull() {
            addCriterion("law_id_code is not null");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeEqualTo(String value) {
            addCriterion("law_id_code =", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeNotEqualTo(String value) {
            addCriterion("law_id_code <>", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeGreaterThan(String value) {
            addCriterion("law_id_code >", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeGreaterThanOrEqualTo(String value) {
            addCriterion("law_id_code >=", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeLessThan(String value) {
            addCriterion("law_id_code <", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeLessThanOrEqualTo(String value) {
            addCriterion("law_id_code <=", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeLike(String value) {
            addCriterion("law_id_code like", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeNotLike(String value) {
            addCriterion("law_id_code not like", value, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeIn(List<String> values) {
            addCriterion("law_id_code in", values, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeNotIn(List<String> values) {
            addCriterion("law_id_code not in", values, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeBetween(String value1, String value2) {
            addCriterion("law_id_code between", value1, value2, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeNotBetween(String value1, String value2) {
            addCriterion("law_id_code not between", value1, value2, "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawPhoneIsNull() {
            addCriterion("law_phone is null");
            return (Criteria) this;
        }

        public Criteria andLawPhoneIsNotNull() {
            addCriterion("law_phone is not null");
            return (Criteria) this;
        }

        public Criteria andLawPhoneEqualTo(String value) {
            addCriterion("law_phone =", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneNotEqualTo(String value) {
            addCriterion("law_phone <>", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneGreaterThan(String value) {
            addCriterion("law_phone >", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("law_phone >=", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneLessThan(String value) {
            addCriterion("law_phone <", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneLessThanOrEqualTo(String value) {
            addCriterion("law_phone <=", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneLike(String value) {
            addCriterion("law_phone like", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneNotLike(String value) {
            addCriterion("law_phone not like", value, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneIn(List<String> values) {
            addCriterion("law_phone in", values, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneNotIn(List<String> values) {
            addCriterion("law_phone not in", values, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneBetween(String value1, String value2) {
            addCriterion("law_phone between", value1, value2, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPhoneNotBetween(String value1, String value2) {
            addCriterion("law_phone not between", value1, value2, "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPicMainIsNull() {
            addCriterion("law_pic_main is null");
            return (Criteria) this;
        }

        public Criteria andLawPicMainIsNotNull() {
            addCriterion("law_pic_main is not null");
            return (Criteria) this;
        }

        public Criteria andLawPicMainEqualTo(String value) {
            addCriterion("law_pic_main =", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainNotEqualTo(String value) {
            addCriterion("law_pic_main <>", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainGreaterThan(String value) {
            addCriterion("law_pic_main >", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainGreaterThanOrEqualTo(String value) {
            addCriterion("law_pic_main >=", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainLessThan(String value) {
            addCriterion("law_pic_main <", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainLessThanOrEqualTo(String value) {
            addCriterion("law_pic_main <=", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainLike(String value) {
            addCriterion("law_pic_main like", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainNotLike(String value) {
            addCriterion("law_pic_main not like", value, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainIn(List<String> values) {
            addCriterion("law_pic_main in", values, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainNotIn(List<String> values) {
            addCriterion("law_pic_main not in", values, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainBetween(String value1, String value2) {
            addCriterion("law_pic_main between", value1, value2, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicMainNotBetween(String value1, String value2) {
            addCriterion("law_pic_main not between", value1, value2, "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherIsNull() {
            addCriterion("law_pic_other is null");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherIsNotNull() {
            addCriterion("law_pic_other is not null");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherEqualTo(String value) {
            addCriterion("law_pic_other =", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherNotEqualTo(String value) {
            addCriterion("law_pic_other <>", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherGreaterThan(String value) {
            addCriterion("law_pic_other >", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherGreaterThanOrEqualTo(String value) {
            addCriterion("law_pic_other >=", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherLessThan(String value) {
            addCriterion("law_pic_other <", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherLessThanOrEqualTo(String value) {
            addCriterion("law_pic_other <=", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherLike(String value) {
            addCriterion("law_pic_other like", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherNotLike(String value) {
            addCriterion("law_pic_other not like", value, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherIn(List<String> values) {
            addCriterion("law_pic_other in", values, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherNotIn(List<String> values) {
            addCriterion("law_pic_other not in", values, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherBetween(String value1, String value2) {
            addCriterion("law_pic_other between", value1, value2, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherNotBetween(String value1, String value2) {
            addCriterion("law_pic_other not between", value1, value2, "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andLawValidDateIsNull() {
            addCriterion("law_valid_date is null");
            return (Criteria) this;
        }

        public Criteria andLawValidDateIsNotNull() {
            addCriterion("law_valid_date is not null");
            return (Criteria) this;
        }

        public Criteria andLawValidDateEqualTo(Date value) {
            addCriterionForJDBCDate("law_valid_date =", value, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("law_valid_date <>", value, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateGreaterThan(Date value) {
            addCriterionForJDBCDate("law_valid_date >", value, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("law_valid_date >=", value, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateLessThan(Date value) {
            addCriterionForJDBCDate("law_valid_date <", value, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("law_valid_date <=", value, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateIn(List<Date> values) {
            addCriterionForJDBCDate("law_valid_date in", values, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("law_valid_date not in", values, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("law_valid_date between", value1, value2, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("law_valid_date not between", value1, value2, "lawValidDate");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusIsNull() {
            addCriterion("law_valid_expired_status is null");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusIsNotNull() {
            addCriterion("law_valid_expired_status is not null");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusEqualTo(Byte value) {
            addCriterion("law_valid_expired_status =", value, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusNotEqualTo(Byte value) {
            addCriterion("law_valid_expired_status <>", value, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusGreaterThan(Byte value) {
            addCriterion("law_valid_expired_status >", value, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusGreaterThanOrEqualTo(Byte value) {
            addCriterion("law_valid_expired_status >=", value, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusLessThan(Byte value) {
            addCriterion("law_valid_expired_status <", value, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusLessThanOrEqualTo(Byte value) {
            addCriterion("law_valid_expired_status <=", value, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusIn(List<Byte> values) {
            addCriterion("law_valid_expired_status in", values, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusNotIn(List<Byte> values) {
            addCriterion("law_valid_expired_status not in", values, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusBetween(Byte value1, Byte value2) {
            addCriterion("law_valid_expired_status between", value1, value2, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andLawValidExpiredStatusNotBetween(Byte value1, Byte value2) {
            addCriterion("law_valid_expired_status not between", value1, value2, "lawValidExpiredStatus");
            return (Criteria) this;
        }

        public Criteria andBlCodeIsNull() {
            addCriterion("bl_code is null");
            return (Criteria) this;
        }

        public Criteria andBlCodeIsNotNull() {
            addCriterion("bl_code is not null");
            return (Criteria) this;
        }

        public Criteria andBlCodeEqualTo(String value) {
            addCriterion("bl_code =", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeNotEqualTo(String value) {
            addCriterion("bl_code <>", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeGreaterThan(String value) {
            addCriterion("bl_code >", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeGreaterThanOrEqualTo(String value) {
            addCriterion("bl_code >=", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeLessThan(String value) {
            addCriterion("bl_code <", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeLessThanOrEqualTo(String value) {
            addCriterion("bl_code <=", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeLike(String value) {
            addCriterion("bl_code like", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeNotLike(String value) {
            addCriterion("bl_code not like", value, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeIn(List<String> values) {
            addCriterion("bl_code in", values, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeNotIn(List<String> values) {
            addCriterion("bl_code not in", values, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeBetween(String value1, String value2) {
            addCriterion("bl_code between", value1, value2, "blCode");
            return (Criteria) this;
        }

        public Criteria andBlCodeNotBetween(String value1, String value2) {
            addCriterion("bl_code not between", value1, value2, "blCode");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeIsNull() {
            addCriterion("company_type is null");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeIsNotNull() {
            addCriterion("company_type is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeEqualTo(Byte value) {
            addCriterion("company_type =", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotEqualTo(Byte value) {
            addCriterion("company_type <>", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeGreaterThan(Byte value) {
            addCriterion("company_type >", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("company_type >=", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeLessThan(Byte value) {
            addCriterion("company_type <", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeLessThanOrEqualTo(Byte value) {
            addCriterion("company_type <=", value, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeIn(List<Byte> values) {
            addCriterion("company_type in", values, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotIn(List<Byte> values) {
            addCriterion("company_type not in", values, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeBetween(Byte value1, Byte value2) {
            addCriterion("company_type between", value1, value2, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("company_type not between", value1, value2, "companyType");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressIsNull() {
            addCriterion("company_address is null");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressIsNotNull() {
            addCriterion("company_address is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressEqualTo(String value) {
            addCriterion("company_address =", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotEqualTo(String value) {
            addCriterion("company_address <>", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressGreaterThan(String value) {
            addCriterion("company_address >", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressGreaterThanOrEqualTo(String value) {
            addCriterion("company_address >=", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLessThan(String value) {
            addCriterion("company_address <", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLessThanOrEqualTo(String value) {
            addCriterion("company_address <=", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLike(String value) {
            addCriterion("company_address like", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotLike(String value) {
            addCriterion("company_address not like", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressIn(List<String> values) {
            addCriterion("company_address in", values, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotIn(List<String> values) {
            addCriterion("company_address not in", values, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressBetween(String value1, String value2) {
            addCriterion("company_address between", value1, value2, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotBetween(String value1, String value2) {
            addCriterion("company_address not between", value1, value2, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractCompanyIsNull() {
            addCriterion("contract_company is null");
            return (Criteria) this;
        }

        public Criteria andContractCompanyIsNotNull() {
            addCriterion("contract_company is not null");
            return (Criteria) this;
        }

        public Criteria andContractCompanyEqualTo(String value) {
            addCriterion("contract_company =", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyNotEqualTo(String value) {
            addCriterion("contract_company <>", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyGreaterThan(String value) {
            addCriterion("contract_company >", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("contract_company >=", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyLessThan(String value) {
            addCriterion("contract_company <", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyLessThanOrEqualTo(String value) {
            addCriterion("contract_company <=", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyLike(String value) {
            addCriterion("contract_company like", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyNotLike(String value) {
            addCriterion("contract_company not like", value, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyIn(List<String> values) {
            addCriterion("contract_company in", values, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyNotIn(List<String> values) {
            addCriterion("contract_company not in", values, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyBetween(String value1, String value2) {
            addCriterion("contract_company between", value1, value2, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractCompanyNotBetween(String value1, String value2) {
            addCriterion("contract_company not between", value1, value2, "contractCompany");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNull() {
            addCriterion("contract_end_date is null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNotNull() {
            addCriterion("contract_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date =", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date <>", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThan(Date value) {
            addCriterionForJDBCDate("contract_end_date >", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date >=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThan(Date value) {
            addCriterionForJDBCDate("contract_end_date <", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date <=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIn(List<Date> values) {
            addCriterionForJDBCDate("contract_end_date in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("contract_end_date not in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("contract_end_date between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("contract_end_date not between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andBlPicIsNull() {
            addCriterion("bl_pic is null");
            return (Criteria) this;
        }

        public Criteria andBlPicIsNotNull() {
            addCriterion("bl_pic is not null");
            return (Criteria) this;
        }

        public Criteria andBlPicEqualTo(String value) {
            addCriterion("bl_pic =", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicNotEqualTo(String value) {
            addCriterion("bl_pic <>", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicGreaterThan(String value) {
            addCriterion("bl_pic >", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicGreaterThanOrEqualTo(String value) {
            addCriterion("bl_pic >=", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicLessThan(String value) {
            addCriterion("bl_pic <", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicLessThanOrEqualTo(String value) {
            addCriterion("bl_pic <=", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicLike(String value) {
            addCriterion("bl_pic like", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicNotLike(String value) {
            addCriterion("bl_pic not like", value, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicIn(List<String> values) {
            addCriterion("bl_pic in", values, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicNotIn(List<String> values) {
            addCriterion("bl_pic not in", values, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicBetween(String value1, String value2) {
            addCriterion("bl_pic between", value1, value2, "blPic");
            return (Criteria) this;
        }

        public Criteria andBlPicNotBetween(String value1, String value2) {
            addCriterion("bl_pic not between", value1, value2, "blPic");
            return (Criteria) this;
        }

        public Criteria andAccountIsNull() {
            addCriterion("account is null");
            return (Criteria) this;
        }

        public Criteria andAccountIsNotNull() {
            addCriterion("account is not null");
            return (Criteria) this;
        }

        public Criteria andAccountEqualTo(BigDecimal value) {
            addCriterion("account =", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotEqualTo(BigDecimal value) {
            addCriterion("account <>", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThan(BigDecimal value) {
            addCriterion("account >", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("account >=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThan(BigDecimal value) {
            addCriterion("account <", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("account <=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountIn(List<BigDecimal> values) {
            addCriterion("account in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotIn(List<BigDecimal> values) {
            addCriterion("account not in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("account between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("account not between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andLockAccountIsNull() {
            addCriterion("lock_account is null");
            return (Criteria) this;
        }

        public Criteria andLockAccountIsNotNull() {
            addCriterion("lock_account is not null");
            return (Criteria) this;
        }

        public Criteria andLockAccountEqualTo(BigDecimal value) {
            addCriterion("lock_account =", value, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountNotEqualTo(BigDecimal value) {
            addCriterion("lock_account <>", value, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountGreaterThan(BigDecimal value) {
            addCriterion("lock_account >", value, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("lock_account >=", value, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountLessThan(BigDecimal value) {
            addCriterion("lock_account <", value, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("lock_account <=", value, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountIn(List<BigDecimal> values) {
            addCriterion("lock_account in", values, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountNotIn(List<BigDecimal> values) {
            addCriterion("lock_account not in", values, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("lock_account between", value1, value2, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andLockAccountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("lock_account not between", value1, value2, "lockAccount");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdIsNull() {
            addCriterion("unionbank_id is null");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdIsNotNull() {
            addCriterion("unionbank_id is not null");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdEqualTo(String value) {
            addCriterion("unionbank_id =", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdNotEqualTo(String value) {
            addCriterion("unionbank_id <>", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdGreaterThan(String value) {
            addCriterion("unionbank_id >", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdGreaterThanOrEqualTo(String value) {
            addCriterion("unionbank_id >=", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdLessThan(String value) {
            addCriterion("unionbank_id <", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdLessThanOrEqualTo(String value) {
            addCriterion("unionbank_id <=", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdLike(String value) {
            addCriterion("unionbank_id like", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdNotLike(String value) {
            addCriterion("unionbank_id not like", value, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdIn(List<String> values) {
            addCriterion("unionbank_id in", values, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdNotIn(List<String> values) {
            addCriterion("unionbank_id not in", values, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdBetween(String value1, String value2) {
            addCriterion("unionbank_id between", value1, value2, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdNotBetween(String value1, String value2) {
            addCriterion("unionbank_id not between", value1, value2, "unionbankId");
            return (Criteria) this;
        }

        public Criteria andWalletnumIsNull() {
            addCriterion("walletnum is null");
            return (Criteria) this;
        }

        public Criteria andWalletnumIsNotNull() {
            addCriterion("walletnum is not null");
            return (Criteria) this;
        }

        public Criteria andWalletnumEqualTo(String value) {
            addCriterion("walletnum =", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumNotEqualTo(String value) {
            addCriterion("walletnum <>", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumGreaterThan(String value) {
            addCriterion("walletnum >", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumGreaterThanOrEqualTo(String value) {
            addCriterion("walletnum >=", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumLessThan(String value) {
            addCriterion("walletnum <", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumLessThanOrEqualTo(String value) {
            addCriterion("walletnum <=", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumLike(String value) {
            addCriterion("walletnum like", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumNotLike(String value) {
            addCriterion("walletnum not like", value, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumIn(List<String> values) {
            addCriterion("walletnum in", values, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumNotIn(List<String> values) {
            addCriterion("walletnum not in", values, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumBetween(String value1, String value2) {
            addCriterion("walletnum between", value1, value2, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumNotBetween(String value1, String value2) {
            addCriterion("walletnum not between", value1, value2, "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateIsNull() {
            addCriterion("walletnum_state is null");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateIsNotNull() {
            addCriterion("walletnum_state is not null");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateEqualTo(String value) {
            addCriterion("walletnum_state =", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateNotEqualTo(String value) {
            addCriterion("walletnum_state <>", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateGreaterThan(String value) {
            addCriterion("walletnum_state >", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateGreaterThanOrEqualTo(String value) {
            addCriterion("walletnum_state >=", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateLessThan(String value) {
            addCriterion("walletnum_state <", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateLessThanOrEqualTo(String value) {
            addCriterion("walletnum_state <=", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateLike(String value) {
            addCriterion("walletnum_state like", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateNotLike(String value) {
            addCriterion("walletnum_state not like", value, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateIn(List<String> values) {
            addCriterion("walletnum_state in", values, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateNotIn(List<String> values) {
            addCriterion("walletnum_state not in", values, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateBetween(String value1, String value2) {
            addCriterion("walletnum_state between", value1, value2, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateNotBetween(String value1, String value2) {
            addCriterion("walletnum_state not between", value1, value2, "walletnumState");
            return (Criteria) this;
        }

        public Criteria andBankcodeIsNull() {
            addCriterion("bankcode is null");
            return (Criteria) this;
        }

        public Criteria andBankcodeIsNotNull() {
            addCriterion("bankcode is not null");
            return (Criteria) this;
        }

        public Criteria andBankcodeEqualTo(String value) {
            addCriterion("bankcode =", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotEqualTo(String value) {
            addCriterion("bankcode <>", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeGreaterThan(String value) {
            addCriterion("bankcode >", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeGreaterThanOrEqualTo(String value) {
            addCriterion("bankcode >=", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLessThan(String value) {
            addCriterion("bankcode <", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLessThanOrEqualTo(String value) {
            addCriterion("bankcode <=", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLike(String value) {
            addCriterion("bankcode like", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotLike(String value) {
            addCriterion("bankcode not like", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeIn(List<String> values) {
            addCriterion("bankcode in", values, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotIn(List<String> values) {
            addCriterion("bankcode not in", values, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeBetween(String value1, String value2) {
            addCriterion("bankcode between", value1, value2, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotBetween(String value1, String value2) {
            addCriterion("bankcode not between", value1, value2, "bankcode");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoIsNull() {
            addCriterion("kekeing_sub_account_no is null");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoIsNotNull() {
            addCriterion("kekeing_sub_account_no is not null");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoEqualTo(String value) {
            addCriterion("kekeing_sub_account_no =", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoNotEqualTo(String value) {
            addCriterion("kekeing_sub_account_no <>", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoGreaterThan(String value) {
            addCriterion("kekeing_sub_account_no >", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoGreaterThanOrEqualTo(String value) {
            addCriterion("kekeing_sub_account_no >=", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoLessThan(String value) {
            addCriterion("kekeing_sub_account_no <", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoLessThanOrEqualTo(String value) {
            addCriterion("kekeing_sub_account_no <=", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoLike(String value) {
            addCriterion("kekeing_sub_account_no like", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoNotLike(String value) {
            addCriterion("kekeing_sub_account_no not like", value, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoIn(List<String> values) {
            addCriterion("kekeing_sub_account_no in", values, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoNotIn(List<String> values) {
            addCriterion("kekeing_sub_account_no not in", values, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoBetween(String value1, String value2) {
            addCriterion("kekeing_sub_account_no between", value1, value2, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoNotBetween(String value1, String value2) {
            addCriterion("kekeing_sub_account_no not between", value1, value2, "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameIsNull() {
            addCriterion("kekeing_account_name is null");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameIsNotNull() {
            addCriterion("kekeing_account_name is not null");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameEqualTo(String value) {
            addCriterion("kekeing_account_name =", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameNotEqualTo(String value) {
            addCriterion("kekeing_account_name <>", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameGreaterThan(String value) {
            addCriterion("kekeing_account_name >", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameGreaterThanOrEqualTo(String value) {
            addCriterion("kekeing_account_name >=", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameLessThan(String value) {
            addCriterion("kekeing_account_name <", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameLessThanOrEqualTo(String value) {
            addCriterion("kekeing_account_name <=", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameLike(String value) {
            addCriterion("kekeing_account_name like", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameNotLike(String value) {
            addCriterion("kekeing_account_name not like", value, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameIn(List<String> values) {
            addCriterion("kekeing_account_name in", values, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameNotIn(List<String> values) {
            addCriterion("kekeing_account_name not in", values, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameBetween(String value1, String value2) {
            addCriterion("kekeing_account_name between", value1, value2, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameNotBetween(String value1, String value2) {
            addCriterion("kekeing_account_name not between", value1, value2, "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoIsNull() {
            addCriterion("kekeing_pay_sub_account_no is null");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoIsNotNull() {
            addCriterion("kekeing_pay_sub_account_no is not null");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoEqualTo(String value) {
            addCriterion("kekeing_pay_sub_account_no =", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoNotEqualTo(String value) {
            addCriterion("kekeing_pay_sub_account_no <>", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoGreaterThan(String value) {
            addCriterion("kekeing_pay_sub_account_no >", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoGreaterThanOrEqualTo(String value) {
            addCriterion("kekeing_pay_sub_account_no >=", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoLessThan(String value) {
            addCriterion("kekeing_pay_sub_account_no <", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoLessThanOrEqualTo(String value) {
            addCriterion("kekeing_pay_sub_account_no <=", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoLike(String value) {
            addCriterion("kekeing_pay_sub_account_no like", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoNotLike(String value) {
            addCriterion("kekeing_pay_sub_account_no not like", value, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoIn(List<String> values) {
            addCriterion("kekeing_pay_sub_account_no in", values, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoNotIn(List<String> values) {
            addCriterion("kekeing_pay_sub_account_no not in", values, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoBetween(String value1, String value2) {
            addCriterion("kekeing_pay_sub_account_no between", value1, value2, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoNotBetween(String value1, String value2) {
            addCriterion("kekeing_pay_sub_account_no not between", value1, value2, "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneIsNull() {
            addCriterion("invitePhone is null");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneIsNotNull() {
            addCriterion("invitePhone is not null");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneEqualTo(String value) {
            addCriterion("invitePhone =", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneNotEqualTo(String value) {
            addCriterion("invitePhone <>", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneGreaterThan(String value) {
            addCriterion("invitePhone >", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneGreaterThanOrEqualTo(String value) {
            addCriterion("invitePhone >=", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneLessThan(String value) {
            addCriterion("invitePhone <", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneLessThanOrEqualTo(String value) {
            addCriterion("invitePhone <=", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneLike(String value) {
            addCriterion("invitePhone like", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneNotLike(String value) {
            addCriterion("invitePhone not like", value, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneIn(List<String> values) {
            addCriterion("invitePhone in", values, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneNotIn(List<String> values) {
            addCriterion("invitePhone not in", values, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneBetween(String value1, String value2) {
            addCriterion("invitePhone between", value1, value2, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneNotBetween(String value1, String value2) {
            addCriterion("invitePhone not between", value1, value2, "invitePhone");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNull() {
            addCriterion("province_code is null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIsNotNull() {
            addCriterion("province_code is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeEqualTo(String value) {
            addCriterion("province_code =", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotEqualTo(String value) {
            addCriterion("province_code <>", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThan(String value) {
            addCriterion("province_code >", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("province_code >=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThan(String value) {
            addCriterion("province_code <", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLessThanOrEqualTo(String value) {
            addCriterion("province_code <=", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLike(String value) {
            addCriterion("province_code like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotLike(String value) {
            addCriterion("province_code not like", value, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeIn(List<String> values) {
            addCriterion("province_code in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotIn(List<String> values) {
            addCriterion("province_code not in", values, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeBetween(String value1, String value2) {
            addCriterion("province_code between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeNotBetween(String value1, String value2) {
            addCriterion("province_code not between", value1, value2, "provinceCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNull() {
            addCriterion("city_code is null");
            return (Criteria) this;
        }

        public Criteria andCityCodeIsNotNull() {
            addCriterion("city_code is not null");
            return (Criteria) this;
        }

        public Criteria andCityCodeEqualTo(String value) {
            addCriterion("city_code =", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotEqualTo(String value) {
            addCriterion("city_code <>", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThan(String value) {
            addCriterion("city_code >", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("city_code >=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThan(String value) {
            addCriterion("city_code <", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLessThanOrEqualTo(String value) {
            addCriterion("city_code <=", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLike(String value) {
            addCriterion("city_code like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotLike(String value) {
            addCriterion("city_code not like", value, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeIn(List<String> values) {
            addCriterion("city_code in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotIn(List<String> values) {
            addCriterion("city_code not in", values, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeBetween(String value1, String value2) {
            addCriterion("city_code between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeNotBetween(String value1, String value2) {
            addCriterion("city_code not between", value1, value2, "cityCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNull() {
            addCriterion("company_code is null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNotNull() {
            addCriterion("company_code is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeEqualTo(String value) {
            addCriterion("company_code =", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotEqualTo(String value) {
            addCriterion("company_code <>", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThan(String value) {
            addCriterion("company_code >", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("company_code >=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThan(String value) {
            addCriterion("company_code <", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("company_code <=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLike(String value) {
            addCriterion("company_code like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotLike(String value) {
            addCriterion("company_code not like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIn(List<String> values) {
            addCriterion("company_code in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotIn(List<String> values) {
            addCriterion("company_code not in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeBetween(String value1, String value2) {
            addCriterion("company_code between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("company_code not between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeIsNull() {
            addCriterion("quick_business_company_code is null");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeIsNotNull() {
            addCriterion("quick_business_company_code is not null");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeEqualTo(String value) {
            addCriterion("quick_business_company_code =", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeNotEqualTo(String value) {
            addCriterion("quick_business_company_code <>", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeGreaterThan(String value) {
            addCriterion("quick_business_company_code >", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("quick_business_company_code >=", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeLessThan(String value) {
            addCriterion("quick_business_company_code <", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("quick_business_company_code <=", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeLike(String value) {
            addCriterion("quick_business_company_code like", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeNotLike(String value) {
            addCriterion("quick_business_company_code not like", value, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeIn(List<String> values) {
            addCriterion("quick_business_company_code in", values, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeNotIn(List<String> values) {
            addCriterion("quick_business_company_code not in", values, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeBetween(String value1, String value2) {
            addCriterion("quick_business_company_code between", value1, value2, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("quick_business_company_code not between", value1, value2, "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeIsNull() {
            addCriterion("online_business_company_code is null");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeIsNotNull() {
            addCriterion("online_business_company_code is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeEqualTo(String value) {
            addCriterion("online_business_company_code =", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeNotEqualTo(String value) {
            addCriterion("online_business_company_code <>", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeGreaterThan(String value) {
            addCriterion("online_business_company_code >", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("online_business_company_code >=", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeLessThan(String value) {
            addCriterion("online_business_company_code <", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("online_business_company_code <=", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeLike(String value) {
            addCriterion("online_business_company_code like", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeNotLike(String value) {
            addCriterion("online_business_company_code not like", value, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeIn(List<String> values) {
            addCriterion("online_business_company_code in", values, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeNotIn(List<String> values) {
            addCriterion("online_business_company_code not in", values, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeBetween(String value1, String value2) {
            addCriterion("online_business_company_code between", value1, value2, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("online_business_company_code not between", value1, value2, "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameIsNull() {
            addCriterion("quick_business_company_name is null");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameIsNotNull() {
            addCriterion("quick_business_company_name is not null");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameEqualTo(String value) {
            addCriterion("quick_business_company_name =", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameNotEqualTo(String value) {
            addCriterion("quick_business_company_name <>", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameGreaterThan(String value) {
            addCriterion("quick_business_company_name >", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("quick_business_company_name >=", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameLessThan(String value) {
            addCriterion("quick_business_company_name <", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("quick_business_company_name <=", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameLike(String value) {
            addCriterion("quick_business_company_name like", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameNotLike(String value) {
            addCriterion("quick_business_company_name not like", value, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameIn(List<String> values) {
            addCriterion("quick_business_company_name in", values, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameNotIn(List<String> values) {
            addCriterion("quick_business_company_name not in", values, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameBetween(String value1, String value2) {
            addCriterion("quick_business_company_name between", value1, value2, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameNotBetween(String value1, String value2) {
            addCriterion("quick_business_company_name not between", value1, value2, "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameIsNull() {
            addCriterion("online_business_company_name is null");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameIsNotNull() {
            addCriterion("online_business_company_name is not null");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameEqualTo(String value) {
            addCriterion("online_business_company_name =", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameNotEqualTo(String value) {
            addCriterion("online_business_company_name <>", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameGreaterThan(String value) {
            addCriterion("online_business_company_name >", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("online_business_company_name >=", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameLessThan(String value) {
            addCriterion("online_business_company_name <", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("online_business_company_name <=", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameLike(String value) {
            addCriterion("online_business_company_name like", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameNotLike(String value) {
            addCriterion("online_business_company_name not like", value, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameIn(List<String> values) {
            addCriterion("online_business_company_name in", values, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameNotIn(List<String> values) {
            addCriterion("online_business_company_name not in", values, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameBetween(String value1, String value2) {
            addCriterion("online_business_company_name between", value1, value2, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameNotBetween(String value1, String value2) {
            addCriterion("online_business_company_name not between", value1, value2, "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIsNull() {
            addCriterion("province_name is null");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIsNotNull() {
            addCriterion("province_name is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceNameEqualTo(String value) {
            addCriterion("province_name =", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotEqualTo(String value) {
            addCriterion("province_name <>", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameGreaterThan(String value) {
            addCriterion("province_name >", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameGreaterThanOrEqualTo(String value) {
            addCriterion("province_name >=", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLessThan(String value) {
            addCriterion("province_name <", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLessThanOrEqualTo(String value) {
            addCriterion("province_name <=", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLike(String value) {
            addCriterion("province_name like", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotLike(String value) {
            addCriterion("province_name not like", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIn(List<String> values) {
            addCriterion("province_name in", values, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotIn(List<String> values) {
            addCriterion("province_name not in", values, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameBetween(String value1, String value2) {
            addCriterion("province_name between", value1, value2, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotBetween(String value1, String value2) {
            addCriterion("province_name not between", value1, value2, "provinceName");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNull() {
            addCriterion("city_name is null");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNotNull() {
            addCriterion("city_name is not null");
            return (Criteria) this;
        }

        public Criteria andCityNameEqualTo(String value) {
            addCriterion("city_name =", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotEqualTo(String value) {
            addCriterion("city_name <>", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThan(String value) {
            addCriterion("city_name >", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("city_name >=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThan(String value) {
            addCriterion("city_name <", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThanOrEqualTo(String value) {
            addCriterion("city_name <=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLike(String value) {
            addCriterion("city_name like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotLike(String value) {
            addCriterion("city_name not like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameIn(List<String> values) {
            addCriterion("city_name in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotIn(List<String> values) {
            addCriterion("city_name not in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameBetween(String value1, String value2) {
            addCriterion("city_name between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotBetween(String value1, String value2) {
            addCriterion("city_name not between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andAuthTypeIsNull() {
            addCriterion("auth_type is null");
            return (Criteria) this;
        }

        public Criteria andAuthTypeIsNotNull() {
            addCriterion("auth_type is not null");
            return (Criteria) this;
        }

        public Criteria andAuthTypeEqualTo(Byte value) {
            addCriterion("auth_type =", value, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeNotEqualTo(Byte value) {
            addCriterion("auth_type <>", value, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeGreaterThan(Byte value) {
            addCriterion("auth_type >", value, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("auth_type >=", value, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeLessThan(Byte value) {
            addCriterion("auth_type <", value, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeLessThanOrEqualTo(Byte value) {
            addCriterion("auth_type <=", value, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeIn(List<Byte> values) {
            addCriterion("auth_type in", values, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeNotIn(List<Byte> values) {
            addCriterion("auth_type not in", values, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeBetween(Byte value1, Byte value2) {
            addCriterion("auth_type between", value1, value2, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("auth_type not between", value1, value2, "authType");
            return (Criteria) this;
        }

        public Criteria andAuthTimeIsNull() {
            addCriterion("auth_time is null");
            return (Criteria) this;
        }

        public Criteria andAuthTimeIsNotNull() {
            addCriterion("auth_time is not null");
            return (Criteria) this;
        }

        public Criteria andAuthTimeEqualTo(Date value) {
            addCriterion("auth_time =", value, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeNotEqualTo(Date value) {
            addCriterion("auth_time <>", value, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeGreaterThan(Date value) {
            addCriterion("auth_time >", value, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("auth_time >=", value, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeLessThan(Date value) {
            addCriterion("auth_time <", value, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeLessThanOrEqualTo(Date value) {
            addCriterion("auth_time <=", value, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeIn(List<Date> values) {
            addCriterion("auth_time in", values, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeNotIn(List<Date> values) {
            addCriterion("auth_time not in", values, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeBetween(Date value1, Date value2) {
            addCriterion("auth_time between", value1, value2, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthTimeNotBetween(Date value1, Date value2) {
            addCriterion("auth_time not between", value1, value2, "authTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeIsNull() {
            addCriterion("auth_pass_time is null");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeIsNotNull() {
            addCriterion("auth_pass_time is not null");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeEqualTo(Date value) {
            addCriterion("auth_pass_time =", value, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeNotEqualTo(Date value) {
            addCriterion("auth_pass_time <>", value, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeGreaterThan(Date value) {
            addCriterion("auth_pass_time >", value, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("auth_pass_time >=", value, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeLessThan(Date value) {
            addCriterion("auth_pass_time <", value, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeLessThanOrEqualTo(Date value) {
            addCriterion("auth_pass_time <=", value, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeIn(List<Date> values) {
            addCriterion("auth_pass_time in", values, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeNotIn(List<Date> values) {
            addCriterion("auth_pass_time not in", values, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeBetween(Date value1, Date value2) {
            addCriterion("auth_pass_time between", value1, value2, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andAuthPassTimeNotBetween(Date value1, Date value2) {
            addCriterion("auth_pass_time not between", value1, value2, "authPassTime");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardIsNull() {
            addCriterion("personal_bank_card is null");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardIsNotNull() {
            addCriterion("personal_bank_card is not null");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardEqualTo(String value) {
            addCriterion("personal_bank_card =", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardNotEqualTo(String value) {
            addCriterion("personal_bank_card <>", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardGreaterThan(String value) {
            addCriterion("personal_bank_card >", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardGreaterThanOrEqualTo(String value) {
            addCriterion("personal_bank_card >=", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardLessThan(String value) {
            addCriterion("personal_bank_card <", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardLessThanOrEqualTo(String value) {
            addCriterion("personal_bank_card <=", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardLike(String value) {
            addCriterion("personal_bank_card like", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardNotLike(String value) {
            addCriterion("personal_bank_card not like", value, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardIn(List<String> values) {
            addCriterion("personal_bank_card in", values, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardNotIn(List<String> values) {
            addCriterion("personal_bank_card not in", values, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardBetween(String value1, String value2) {
            addCriterion("personal_bank_card between", value1, value2, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardNotBetween(String value1, String value2) {
            addCriterion("personal_bank_card not between", value1, value2, "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberIsNull() {
            addCriterion("is_jumeng_member is null");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberIsNotNull() {
            addCriterion("is_jumeng_member is not null");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberEqualTo(Byte value) {
            addCriterion("is_jumeng_member =", value, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberNotEqualTo(Byte value) {
            addCriterion("is_jumeng_member <>", value, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberGreaterThan(Byte value) {
            addCriterion("is_jumeng_member >", value, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberGreaterThanOrEqualTo(Byte value) {
            addCriterion("is_jumeng_member >=", value, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberLessThan(Byte value) {
            addCriterion("is_jumeng_member <", value, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberLessThanOrEqualTo(Byte value) {
            addCriterion("is_jumeng_member <=", value, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberIn(List<Byte> values) {
            addCriterion("is_jumeng_member in", values, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberNotIn(List<Byte> values) {
            addCriterion("is_jumeng_member not in", values, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberBetween(Byte value1, Byte value2) {
            addCriterion("is_jumeng_member between", value1, value2, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andIsJumengMemberNotBetween(Byte value1, Byte value2) {
            addCriterion("is_jumeng_member not between", value1, value2, "isJumengMember");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformIsNull() {
            addCriterion("second_platform is null");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformIsNotNull() {
            addCriterion("second_platform is not null");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformEqualTo(String value) {
            addCriterion("second_platform =", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformNotEqualTo(String value) {
            addCriterion("second_platform <>", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformGreaterThan(String value) {
            addCriterion("second_platform >", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformGreaterThanOrEqualTo(String value) {
            addCriterion("second_platform >=", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformLessThan(String value) {
            addCriterion("second_platform <", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformLessThanOrEqualTo(String value) {
            addCriterion("second_platform <=", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformLike(String value) {
            addCriterion("second_platform like", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformNotLike(String value) {
            addCriterion("second_platform not like", value, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformIn(List<String> values) {
            addCriterion("second_platform in", values, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformNotIn(List<String> values) {
            addCriterion("second_platform not in", values, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformBetween(String value1, String value2) {
            addCriterion("second_platform between", value1, value2, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformNotBetween(String value1, String value2) {
            addCriterion("second_platform not between", value1, value2, "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIsNull() {
            addCriterion("area_code is null");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIsNotNull() {
            addCriterion("area_code is not null");
            return (Criteria) this;
        }

        public Criteria andAreaCodeEqualTo(String value) {
            addCriterion("area_code =", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotEqualTo(String value) {
            addCriterion("area_code <>", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeGreaterThan(String value) {
            addCriterion("area_code >", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeGreaterThanOrEqualTo(String value) {
            addCriterion("area_code >=", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLessThan(String value) {
            addCriterion("area_code <", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLessThanOrEqualTo(String value) {
            addCriterion("area_code <=", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLike(String value) {
            addCriterion("area_code like", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotLike(String value) {
            addCriterion("area_code not like", value, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeIn(List<String> values) {
            addCriterion("area_code in", values, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotIn(List<String> values) {
            addCriterion("area_code not in", values, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeBetween(String value1, String value2) {
            addCriterion("area_code between", value1, value2, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaCodeNotBetween(String value1, String value2) {
            addCriterion("area_code not between", value1, value2, "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaNameIsNull() {
            addCriterion("area_name is null");
            return (Criteria) this;
        }

        public Criteria andAreaNameIsNotNull() {
            addCriterion("area_name is not null");
            return (Criteria) this;
        }

        public Criteria andAreaNameEqualTo(String value) {
            addCriterion("area_name =", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameNotEqualTo(String value) {
            addCriterion("area_name <>", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameGreaterThan(String value) {
            addCriterion("area_name >", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameGreaterThanOrEqualTo(String value) {
            addCriterion("area_name >=", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameLessThan(String value) {
            addCriterion("area_name <", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameLessThanOrEqualTo(String value) {
            addCriterion("area_name <=", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameLike(String value) {
            addCriterion("area_name like", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameNotLike(String value) {
            addCriterion("area_name not like", value, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameIn(List<String> values) {
            addCriterion("area_name in", values, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameNotIn(List<String> values) {
            addCriterion("area_name not in", values, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameBetween(String value1, String value2) {
            addCriterion("area_name between", value1, value2, "areaName");
            return (Criteria) this;
        }

        public Criteria andAreaNameNotBetween(String value1, String value2) {
            addCriterion("area_name not between", value1, value2, "areaName");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeIsNull() {
            addCriterion("tendency_order_type is null");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeIsNotNull() {
            addCriterion("tendency_order_type is not null");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeEqualTo(Byte value) {
            addCriterion("tendency_order_type =", value, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeNotEqualTo(Byte value) {
            addCriterion("tendency_order_type <>", value, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeGreaterThan(Byte value) {
            addCriterion("tendency_order_type >", value, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("tendency_order_type >=", value, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeLessThan(Byte value) {
            addCriterion("tendency_order_type <", value, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeLessThanOrEqualTo(Byte value) {
            addCriterion("tendency_order_type <=", value, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeIn(List<Byte> values) {
            addCriterion("tendency_order_type in", values, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeNotIn(List<Byte> values) {
            addCriterion("tendency_order_type not in", values, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeBetween(Byte value1, Byte value2) {
            addCriterion("tendency_order_type between", value1, value2, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andTendencyOrderTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("tendency_order_type not between", value1, value2, "tendencyOrderType");
            return (Criteria) this;
        }

        public Criteria andDisStatusIsNull() {
            addCriterion("dis_status is null");
            return (Criteria) this;
        }

        public Criteria andDisStatusIsNotNull() {
            addCriterion("dis_status is not null");
            return (Criteria) this;
        }

        public Criteria andDisStatusEqualTo(Boolean value) {
            addCriterion("dis_status =", value, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusNotEqualTo(Boolean value) {
            addCriterion("dis_status <>", value, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusGreaterThan(Boolean value) {
            addCriterion("dis_status >", value, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusGreaterThanOrEqualTo(Boolean value) {
            addCriterion("dis_status >=", value, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusLessThan(Boolean value) {
            addCriterion("dis_status <", value, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusLessThanOrEqualTo(Boolean value) {
            addCriterion("dis_status <=", value, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusIn(List<Boolean> values) {
            addCriterion("dis_status in", values, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusNotIn(List<Boolean> values) {
            addCriterion("dis_status not in", values, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusBetween(Boolean value1, Boolean value2) {
            addCriterion("dis_status between", value1, value2, "disStatus");
            return (Criteria) this;
        }

        public Criteria andDisStatusNotBetween(Boolean value1, Boolean value2) {
            addCriterion("dis_status not between", value1, value2, "disStatus");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("merchant_id is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("merchant_id is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(Long value) {
            addCriterion("merchant_id =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(Long value) {
            addCriterion("merchant_id <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(Long value) {
            addCriterion("merchant_id >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(Long value) {
            addCriterion("merchant_id >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(Long value) {
            addCriterion("merchant_id <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(Long value) {
            addCriterion("merchant_id <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<Long> values) {
            addCriterion("merchant_id in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<Long> values) {
            addCriterion("merchant_id not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(Long value1, Long value2) {
            addCriterion("merchant_id between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(Long value1, Long value2) {
            addCriterion("merchant_id not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateIsNull() {
            addCriterion("cloud_capital_state is null");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateIsNotNull() {
            addCriterion("cloud_capital_state is not null");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateEqualTo(Byte value) {
            addCriterion("cloud_capital_state =", value, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateNotEqualTo(Byte value) {
            addCriterion("cloud_capital_state <>", value, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateGreaterThan(Byte value) {
            addCriterion("cloud_capital_state >", value, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateGreaterThanOrEqualTo(Byte value) {
            addCriterion("cloud_capital_state >=", value, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateLessThan(Byte value) {
            addCriterion("cloud_capital_state <", value, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateLessThanOrEqualTo(Byte value) {
            addCriterion("cloud_capital_state <=", value, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateIn(List<Byte> values) {
            addCriterion("cloud_capital_state in", values, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateNotIn(List<Byte> values) {
            addCriterion("cloud_capital_state not in", values, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateBetween(Byte value1, Byte value2) {
            addCriterion("cloud_capital_state between", value1, value2, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andCloudCapitalStateNotBetween(Byte value1, Byte value2) {
            addCriterion("cloud_capital_state not between", value1, value2, "cloudCapitalState");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonIsNull() {
            addCriterion("audit_fail_reason is null");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonIsNotNull() {
            addCriterion("audit_fail_reason is not null");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonEqualTo(String value) {
            addCriterion("audit_fail_reason =", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonNotEqualTo(String value) {
            addCriterion("audit_fail_reason <>", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonGreaterThan(String value) {
            addCriterion("audit_fail_reason >", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonGreaterThanOrEqualTo(String value) {
            addCriterion("audit_fail_reason >=", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonLessThan(String value) {
            addCriterion("audit_fail_reason <", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonLessThanOrEqualTo(String value) {
            addCriterion("audit_fail_reason <=", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonLike(String value) {
            addCriterion("audit_fail_reason like", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonNotLike(String value) {
            addCriterion("audit_fail_reason not like", value, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonIn(List<String> values) {
            addCriterion("audit_fail_reason in", values, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonNotIn(List<String> values) {
            addCriterion("audit_fail_reason not in", values, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonBetween(String value1, String value2) {
            addCriterion("audit_fail_reason between", value1, value2, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonNotBetween(String value1, String value2) {
            addCriterion("audit_fail_reason not between", value1, value2, "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureIsNull() {
            addCriterion("delivery_nature is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureIsNotNull() {
            addCriterion("delivery_nature is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureEqualTo(Byte value) {
            addCriterion("delivery_nature =", value, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureNotEqualTo(Byte value) {
            addCriterion("delivery_nature <>", value, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureGreaterThan(Byte value) {
            addCriterion("delivery_nature >", value, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureGreaterThanOrEqualTo(Byte value) {
            addCriterion("delivery_nature >=", value, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureLessThan(Byte value) {
            addCriterion("delivery_nature <", value, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureLessThanOrEqualTo(Byte value) {
            addCriterion("delivery_nature <=", value, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureIn(List<Byte> values) {
            addCriterion("delivery_nature in", values, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureNotIn(List<Byte> values) {
            addCriterion("delivery_nature not in", values, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureBetween(Byte value1, Byte value2) {
            addCriterion("delivery_nature between", value1, value2, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andDeliveryNatureNotBetween(Byte value1, Byte value2) {
            addCriterion("delivery_nature not between", value1, value2, "deliveryNature");
            return (Criteria) this;
        }

        public Criteria andCusCodeIsNull() {
            addCriterion("cus_code is null");
            return (Criteria) this;
        }

        public Criteria andCusCodeIsNotNull() {
            addCriterion("cus_code is not null");
            return (Criteria) this;
        }

        public Criteria andCusCodeEqualTo(String value) {
            addCriterion("cus_code =", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeNotEqualTo(String value) {
            addCriterion("cus_code <>", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeGreaterThan(String value) {
            addCriterion("cus_code >", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cus_code >=", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeLessThan(String value) {
            addCriterion("cus_code <", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeLessThanOrEqualTo(String value) {
            addCriterion("cus_code <=", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeLike(String value) {
            addCriterion("cus_code like", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeNotLike(String value) {
            addCriterion("cus_code not like", value, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeIn(List<String> values) {
            addCriterion("cus_code in", values, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeNotIn(List<String> values) {
            addCriterion("cus_code not in", values, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeBetween(String value1, String value2) {
            addCriterion("cus_code between", value1, value2, "cusCode");
            return (Criteria) this;
        }

        public Criteria andCusCodeNotBetween(String value1, String value2) {
            addCriterion("cus_code not between", value1, value2, "cusCode");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateIsNull() {
            addCriterion("three_elements_state is null");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateIsNotNull() {
            addCriterion("three_elements_state is not null");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateEqualTo(String value) {
            addCriterion("three_elements_state =", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateNotEqualTo(String value) {
            addCriterion("three_elements_state <>", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateGreaterThan(String value) {
            addCriterion("three_elements_state >", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateGreaterThanOrEqualTo(String value) {
            addCriterion("three_elements_state >=", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateLessThan(String value) {
            addCriterion("three_elements_state <", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateLessThanOrEqualTo(String value) {
            addCriterion("three_elements_state <=", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateLike(String value) {
            addCriterion("three_elements_state like", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateNotLike(String value) {
            addCriterion("three_elements_state not like", value, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateIn(List<String> values) {
            addCriterion("three_elements_state in", values, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateNotIn(List<String> values) {
            addCriterion("three_elements_state not in", values, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateBetween(String value1, String value2) {
            addCriterion("three_elements_state between", value1, value2, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateNotBetween(String value1, String value2) {
            addCriterion("three_elements_state not between", value1, value2, "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsIsNull() {
            addCriterion("additional_materials is null");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsIsNotNull() {
            addCriterion("additional_materials is not null");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsEqualTo(String value) {
            addCriterion("additional_materials =", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsNotEqualTo(String value) {
            addCriterion("additional_materials <>", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsGreaterThan(String value) {
            addCriterion("additional_materials >", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsGreaterThanOrEqualTo(String value) {
            addCriterion("additional_materials >=", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsLessThan(String value) {
            addCriterion("additional_materials <", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsLessThanOrEqualTo(String value) {
            addCriterion("additional_materials <=", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsLike(String value) {
            addCriterion("additional_materials like", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsNotLike(String value) {
            addCriterion("additional_materials not like", value, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsIn(List<String> values) {
            addCriterion("additional_materials in", values, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsNotIn(List<String> values) {
            addCriterion("additional_materials not in", values, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsBetween(String value1, String value2) {
            addCriterion("additional_materials between", value1, value2, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsNotBetween(String value1, String value2) {
            addCriterion("additional_materials not between", value1, value2, "additionalMaterials");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeIsNull() {
            addCriterion("last_order_time is null");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeIsNotNull() {
            addCriterion("last_order_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeEqualTo(Date value) {
            addCriterion("last_order_time =", value, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeNotEqualTo(Date value) {
            addCriterion("last_order_time <>", value, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeGreaterThan(Date value) {
            addCriterion("last_order_time >", value, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_order_time >=", value, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeLessThan(Date value) {
            addCriterion("last_order_time <", value, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_order_time <=", value, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeIn(List<Date> values) {
            addCriterion("last_order_time in", values, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeNotIn(List<Date> values) {
            addCriterion("last_order_time not in", values, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeBetween(Date value1, Date value2) {
            addCriterion("last_order_time between", value1, value2, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andLastOrderTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_order_time not between", value1, value2, "lastOrderTime");
            return (Criteria) this;
        }

        public Criteria andNameLikeInsensitive(String value) {
            addCriterion("upper(name) like", value.toUpperCase(), "name");
            return (Criteria) this;
        }

        public Criteria andLawRealnameLikeInsensitive(String value) {
            addCriterion("upper(law_realname) like", value.toUpperCase(), "lawRealname");
            return (Criteria) this;
        }

        public Criteria andLawIdCodeLikeInsensitive(String value) {
            addCriterion("upper(law_id_code) like", value.toUpperCase(), "lawIdCode");
            return (Criteria) this;
        }

        public Criteria andLawPhoneLikeInsensitive(String value) {
            addCriterion("upper(law_phone) like", value.toUpperCase(), "lawPhone");
            return (Criteria) this;
        }

        public Criteria andLawPicMainLikeInsensitive(String value) {
            addCriterion("upper(law_pic_main) like", value.toUpperCase(), "lawPicMain");
            return (Criteria) this;
        }

        public Criteria andLawPicOtherLikeInsensitive(String value) {
            addCriterion("upper(law_pic_other) like", value.toUpperCase(), "lawPicOther");
            return (Criteria) this;
        }

        public Criteria andBlCodeLikeInsensitive(String value) {
            addCriterion("upper(bl_code) like", value.toUpperCase(), "blCode");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLikeInsensitive(String value) {
            addCriterion("upper(company_address) like", value.toUpperCase(), "companyAddress");
            return (Criteria) this;
        }

        public Criteria andContractNumberLikeInsensitive(String value) {
            addCriterion("upper(contract_number) like", value.toUpperCase(), "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractCompanyLikeInsensitive(String value) {
            addCriterion("upper(contract_company) like", value.toUpperCase(), "contractCompany");
            return (Criteria) this;
        }

        public Criteria andBlPicLikeInsensitive(String value) {
            addCriterion("upper(bl_pic) like", value.toUpperCase(), "blPic");
            return (Criteria) this;
        }

        public Criteria andUnionbankIdLikeInsensitive(String value) {
            addCriterion("upper(unionbank_id) like", value.toUpperCase(), "unionbankId");
            return (Criteria) this;
        }

        public Criteria andWalletnumLikeInsensitive(String value) {
            addCriterion("upper(walletnum) like", value.toUpperCase(), "walletnum");
            return (Criteria) this;
        }

        public Criteria andWalletnumStateLikeInsensitive(String value) {
            addCriterion("upper(walletnum_state) like", value.toUpperCase(), "walletnumState");
            return (Criteria) this;
        }

        public Criteria andBankcodeLikeInsensitive(String value) {
            addCriterion("upper(bankcode) like", value.toUpperCase(), "bankcode");
            return (Criteria) this;
        }

        public Criteria andKekeingSubAccountNoLikeInsensitive(String value) {
            addCriterion("upper(kekeing_sub_account_no) like", value.toUpperCase(), "kekeingSubAccountNo");
            return (Criteria) this;
        }

        public Criteria andKekeingAccountNameLikeInsensitive(String value) {
            addCriterion("upper(kekeing_account_name) like", value.toUpperCase(), "kekeingAccountName");
            return (Criteria) this;
        }

        public Criteria andKekeingPaySubAccountNoLikeInsensitive(String value) {
            addCriterion("upper(kekeing_pay_sub_account_no) like", value.toUpperCase(), "kekeingPaySubAccountNo");
            return (Criteria) this;
        }

        public Criteria andInvitePhoneLikeInsensitive(String value) {
            addCriterion("upper(invitePhone) like", value.toUpperCase(), "invitePhone");
            return (Criteria) this;
        }

        public Criteria andProvinceCodeLikeInsensitive(String value) {
            addCriterion("upper(province_code) like", value.toUpperCase(), "provinceCode");
            return (Criteria) this;
        }

        public Criteria andCityCodeLikeInsensitive(String value) {
            addCriterion("upper(city_code) like", value.toUpperCase(), "cityCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLikeInsensitive(String value) {
            addCriterion("upper(company_code) like", value.toUpperCase(), "companyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyCodeLikeInsensitive(String value) {
            addCriterion("upper(quick_business_company_code) like", value.toUpperCase(), "quickBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyCodeLikeInsensitive(String value) {
            addCriterion("upper(online_business_company_code) like", value.toUpperCase(), "onlineBusinessCompanyCode");
            return (Criteria) this;
        }

        public Criteria andQuickBusinessCompanyNameLikeInsensitive(String value) {
            addCriterion("upper(quick_business_company_name) like", value.toUpperCase(), "quickBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andOnlineBusinessCompanyNameLikeInsensitive(String value) {
            addCriterion("upper(online_business_company_name) like", value.toUpperCase(), "onlineBusinessCompanyName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLikeInsensitive(String value) {
            addCriterion("upper(province_name) like", value.toUpperCase(), "provinceName");
            return (Criteria) this;
        }

        public Criteria andCityNameLikeInsensitive(String value) {
            addCriterion("upper(city_name) like", value.toUpperCase(), "cityName");
            return (Criteria) this;
        }

        public Criteria andPersonalBankCardLikeInsensitive(String value) {
            addCriterion("upper(personal_bank_card) like", value.toUpperCase(), "personalBankCard");
            return (Criteria) this;
        }

        public Criteria andSecondPlatformLikeInsensitive(String value) {
            addCriterion("upper(second_platform) like", value.toUpperCase(), "secondPlatform");
            return (Criteria) this;
        }

        public Criteria andAreaCodeLikeInsensitive(String value) {
            addCriterion("upper(area_code) like", value.toUpperCase(), "areaCode");
            return (Criteria) this;
        }

        public Criteria andAreaNameLikeInsensitive(String value) {
            addCriterion("upper(area_name) like", value.toUpperCase(), "areaName");
            return (Criteria) this;
        }

        public Criteria andAuditFailReasonLikeInsensitive(String value) {
            addCriterion("upper(audit_fail_reason) like", value.toUpperCase(), "auditFailReason");
            return (Criteria) this;
        }

        public Criteria andCusCodeLikeInsensitive(String value) {
            addCriterion("upper(cus_code) like", value.toUpperCase(), "cusCode");
            return (Criteria) this;
        }

        public Criteria andThreeElementsStateLikeInsensitive(String value) {
            addCriterion("upper(three_elements_state) like", value.toUpperCase(), "threeElementsState");
            return (Criteria) this;
        }

        public Criteria andAdditionalMaterialsLikeInsensitive(String value) {
            addCriterion("upper(additional_materials) like", value.toUpperCase(), "additionalMaterials");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria implements java.io.Serializable {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion implements java.io.Serializable {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}